package com.zyd.dao;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author: Wangbo
 * @date: 2019/3/4
 */
@Repository
public class SafeDao {

    @Autowired
    private JdbcTemplate template;

    public List findSafeByArea(String area) {
        return template.queryForList("SELECT id,salename,salemny,saledesc,yearnum,ts,createid,createtime,has_accient,has_third,has_theft,other_money,area FROM zydzn_safe WHERE dr='0' AND area=? ",area);
    }
}
